PersonNameSuffix

Entity Definition

Logical Name : PersonNameSuffix
Physical Name : PA_PRS_NM_SFX

Suffixes that a Person uses.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
NameSuffixCode (FK)(PK) A code that describes a name suffix. For example, junior, senior, III, Ph.D., etc. LU_NM_SFX Code6 char(6) NameSuffix(PA_NM_SFX)
PersonPartyID (FK)(PK) A unique, system assigned identity for a Party. ID_PRTY_PRS Identity integer Person(PA_PRS)
RelativeOrderNumber The relative position of a suffix for a specific person. AI_ORD_RLTV Number integer

Relationships

Parent Entity Verb Phrase Child Entity
NameSuffix is used by PersonNameSuffix
Person uses PersonNameSuffix

Logical Views containing PersonNameSuffix

Logical View
Logical 06315 - Party - Person Names View
Logical 06320 - Party - Address and Contact View
Logical 06330 - Party - Identification View
Logical 07010 - Customer Account Information Extended